Release 10.1A: OpenEdge Data Management:
SQL Reference

Date-time data types

Date-time data types are used to define points in time. Date-time data types represent calendar dates as well as times in This is the syntax for the date-time data types;

Syntax

DATE | TIME | TIMESTAMP

DATE

Stores a date value as three parts: year, month, and day. The ranges for the parts are:

Year: 1 to 9999.
Month: 1 to 12.
Day: Lower limit is 1; the upper limit depends on the month and the year.

TIME

Stores a time value as four parts: hours, minutes, seconds, and milliseconds. The ranges for the parts are:

Hours: 0 to 23.
Minutes: 0 to 59.
Seconds: 0 to 59.
Milliseconds: 0 to 999.

TIMESTAMP

Combines the parts of DATE and TIME.